Dataset info
| Number of variables | 63 |
|---|---|
| Number of observations | 5455 |
| Missing cells | 153013 (44.5%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 2.5 MiB |
| Average record size in memory | 476.0 B |
Variables types
| Numeric | 3 |
|---|---|
| Categorical | 41 |
| Boolean | 3 |
| Date | 6 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 10 |
| Unsupported | 0 |
Warnings
BAR_CODE has a high cardinality: 93 distinct values | Warning |
BAR_CODE has 5276 (96.7%) missing values | Missing |
BIRTH_DATE has 1061 (19.5%) missing values | Missing |
BT_ID has 5445 (99.8%) missing values | Missing |
CATEGORY has 718 (13.2%) missing values | Missing |
CHAPTER has 3065 (56.2%) missing values | Missing |
CITY has a high cardinality: 1708 distinct values | Warning |
CITY has 204 (3.7%) missing values | Missing |
CO_ID has 3471 (63.6%) missing values | Missing |
CO_MEMBER_TYPE has 3471 (63.6%) missing values | Missing |
COMPANY has a high cardinality: 401 distinct values | Warning |
COMPANY has 3092 (56.7%) missing values | Missing |
COMPANY_SORT has a high cardinality: 388 distinct values | Warning |
COMPANY_SORT has 3092 (56.7%) missing values | Missing |
CONTACT_RANK has constant value "0" | Rejected |
COUNTRY has 206 (3.8%) missing values | Missing |
COUNTY has a high cardinality: 507 distinct values | Warning |
COUNTY has 3576 (65.6%) missing values | Missing |
CRRT has constant value "nan" | Rejected |
DESIGNATION has 5429 (99.5%) missing values | Missing |
DISPLAY_CURRENCY has constant value "nan" | Rejected |
DUP_MATCH_KEY has a high cardinality: 5387 distinct values | Warning |
EMAIL has a high cardinality: 4543 distinct values | Warning |
EMAIL has 556 (10.2%) missing values | Missing |
EXCLUDE_MAIL has constant value "False" | Rejected |
FAX has a high cardinality: 53 distinct values | Warning |
FAX has 4776 (87.6%) missing values | Missing |
FIRST_NAME has a high cardinality: 1224 distinct values | Warning |
FIRST_NAME has 373 (6.8%) missing values | Missing |
FULL_ADDRESS has a high cardinality: 3229 distinct values | Warning |
FULL_ADDRESS has 165 (3.0%) missing values | Missing |
FULL_NAME has a high cardinality: 5213 distinct values | Warning |
FULL_NAME has 228 (4.2%) missing values | Missing |
FUNCTIONAL_TITLE has 5441 (99.7%) missing values | Missing |
GENDER has 1148 (21.0%) missing values | Missing |
HOME_PHONE has a high cardinality: 112 distinct values | Warning |
HOME_PHONE has 5328 (97.7%) missing values | Missing |
INFORMAL has a high cardinality: 1185 distinct values | Warning |
INFORMAL has 407 (7.5%) missing values | Missing |
INTENT_TO_EDIT has a high cardinality: 58 distinct values | Warning |
INTENT_TO_EDIT has 5398 (99.0%) missing values | Missing |
JOIN_DATE has 843 (15.5%) missing values | Missing |
LAST_FIRST has a high cardinality: 5198 distinct values | Warning |
LAST_FIRST has 228 (4.2%) missing values | Missing |
LAST_NAME has a high cardinality: 3022 distinct values | Warning |
LAST_NAME has 232 (4.3%) missing values | Missing |
MAIL_CODE has constant value "nan" | Rejected |
MAJOR_KEY has 509 (9.3%) missing values | Missing |
MEMBER_STATUS has 2733 (50.1%) missing values | Missing |
MEMBER_STATUS_DATE has 2786 (51.1%) missing values | Missing |
MIDDLE_NAME has a high cardinality: 98 distinct values | Warning |
MIDDLE_NAME has 2995 (54.9%) missing values | Missing |
MOBILE_PHONE has 5446 (99.8%) missing values | Missing |
MT_CHANGE_DATE has 5203 (95.4%) missing values | Missing |
PAID_THRU has 2963 (54.3%) missing values | Missing |
PartyId is highly correlated with BT_ID (ρ = 1) | Rejected |
PREFIX has 884 (16.2%) missing values | Missing |
PREVIOUS_MT has 5203 (95.4%) missing values | Missing |
SIC_CODE has constant value "nan" | Rejected |
SOURCE_CODE has a high cardinality: 4946 distinct values | Warning |
SOURCE_CODE has 510 (9.3%) missing values | Missing |
STATE_HOUSE has constant value "nan" | Rejected |
STATE_PROVINCE has a high cardinality: 138 distinct values | Warning |
STATE_PROVINCE has 508 (9.3%) missing values | Missing |
STATE_SENATE has constant value "nan" | Rejected |
SUFFIX has 5436 (99.7%) missing values | Missing |
TITLE has a high cardinality: 195 distinct values | Warning |
TITLE has 5107 (93.6%) missing values | Missing |
TOLL_FREE has 5414 (99.2%) missing values | Missing |
US_CONGRESS has constant value "nan" | Rejected |
WEBSITE has a high cardinality: 79 distinct values | Warning |
WEBSITE has 4977 (91.2%) missing values | Missing |
WORK_PHONE has a high cardinality: 2775 distinct values | Warning |
WORK_PHONE has 716 (13.1%) missing values | Missing |
ZIP has a high cardinality: 3008 distinct values | Warning |
ZIP has 202 (3.7%) missing values | Missing |
BAR_CODE
Categorical
| Distinct count | 93 |
|---|---|
| Unique (%) | 1.7% |
| Missing (%) | 96.7% |
| Missing (n) | 5276 |
| /7520671598/ | 20 |
|---|---|
| /900146/ | 15 |
| /787594/ | 11 |
| Other values (89) | 133 |
| (Missing) |
| Value | Count | Frequency (%) | |
| /7520671598/ | 20 | 0.4% | |
| /900146/ | 15 | 0.3% | |
| /787594/ | 11 | 0.2% | |
| /708014/ | 10 | 0.2% | |
| /2231415499/ | 8 | 0.1% | |
| /1000120097/ | 4 | 0.1% | |
| /752439/ | 4 | 0.1% | |
| /787279/ | 3 | 0.1% | |
| /7520687654/ | 3 | 0.1% | |
| /223148/ | 3 | 0.1% | |
| Other values (82) | 98 | 1.8% | |
| (Missing) | 5276 | 96.7% |
| Max length | 12 |
|---|---|
| Mean length | 3.238130156 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
BIRTH_DATE
Date
| Distinct count | 3412 |
|---|---|
| Unique (%) | 62.5% |
| Missing (%) | 19.5% |
| Missing (n) | 1061 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 1941-07-04 00:00:00 |
|---|---|
| Maximum | 2001-02-09 00:00:00 |
BT_ID
Numeric
| Distinct count | 11 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 99.8% |
| Missing (n) | 5445 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 15870.6 |
|---|---|
| Minimum | 243 |
| Maximum | 22155 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 243 |
|---|---|
| 5-th percentile | 251.1 |
| Q1 | 18013.75 |
| Median | 18944.5 |
| Q3 | 20808.75 |
| 95-th percentile | 21714.45 |
| Maximum | 22155 |
| Range | 21912 |
| Interquartile range | 2795 |
Descriptive statistics
| Standard deviation | 8355.560772 |
|---|---|
| Coef of variation | 0.526480459 |
| Kurtosis | 1.154088872 |
| Mean | 15870.6 |
| MAD | 6247.44 |
| Skewness | -1.648537325 |
| Sum | 158706 |
| Variance | 69815395.82 |
| Memory size | 42.7 KiB |
| Value | Count | Frequency (%) | |
| 21176 | 1 | < 0.1% | |
| 18101 | 1 | < 0.1% | |
| 21143 | 1 | < 0.1% | |
| 22155 | 1 | < 0.1% | |
| 243 | 1 | < 0.1% | |
| 18022 | 1 | < 0.1% | |
| 19806 | 1 | < 0.1% | |
| 18011 | 1 | < 0.1% | |
| 19788 | 1 | < 0.1% | |
| 261 | 1 | < 0.1% | |
| (Missing) | 5445 | 99.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 243 | 1 | < 0.1% | |
| 261 | 1 | < 0.1% | |
| 18011 | 1 | < 0.1% | |
| 18022 | 1 | < 0.1% | |
| 18101 | 1 | < 0.1% | |
| 19788 | 1 | < 0.1% | |
| 19806 | 1 | < 0.1% | |
| 21143 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 22155 | 1 | < 0.1% | |
| 21176 | 1 | < 0.1% | |
| 21143 | 1 | < 0.1% | |
| 19806 | 1 | < 0.1% | |
| 19788 | 1 | < 0.1% | |
| 18101 | 1 | < 0.1% | |
| 18022 | 1 | < 0.1% | |
| 18011 | 1 | < 0.1% |
CATEGORY
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 13.2% |
| Missing (n) | 718 |
| 1 | |
|---|---|
| 2 | 1 |
| WEB | 1 |
| (Missing) | 718 |
| Value | Count | Frequency (%) | |
| 1 | 4735 | 86.8% | |
| 2 | 1 | < 0.1% | |
| WEB | 1 | < 0.1% | |
| (Missing) | 718 | 13.2% |
| Max length | 3 |
|---|---|
| Mean length | 1.263611366 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
CHAPTER
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 56.2% |
| Missing (n) | 3065 |
| WEST | |
|---|---|
| NORTH | 420 |
| SOUTH | 406 |
| Other values (4) | 360 |
| (Missing) |
| Value | Count | Frequency (%) | |
| WEST | 1204 | 22.1% | |
| NORTH | 420 | 7.7% | |
| SOUTH | 406 | 7.4% | |
| EAST | 353 | 6.5% | |
| TORONTO | 4 | 0.1% | |
| LONDON | 2 | < 0.1% | |
| TX | 1 | < 0.1% | |
| (Missing) | 3065 | 56.2% |
| Max length | 7 |
|---|---|
| Mean length | 3.592117324 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
CITY
Categorical
| Distinct count | 1708 |
|---|---|
| Unique (%) | 31.3% |
| Missing (%) | 3.7% |
| Missing (n) | 204 |
| London | 216 |
|---|---|
| Los Angeles | 114 |
| New York | 107 |
| Other values (1704) | |
| (Missing) | 204 |
| Value | Count | Frequency (%) | |
| London | 216 | 4.0% | |
| Los Angeles | 114 | 2.1% | |
| New York | 107 | 2.0% | |
| Toronto | 94 | 1.7% | |
| Victoria | 83 | 1.5% | |
| Austin | 81 | 1.5% | |
| Chicago | 77 | 1.4% | |
| Vancouver | 73 | 1.3% | |
| Chesterfield | 72 | 1.3% | |
| Indianapolis | 60 | 1.1% | |
| Other values (1697) | 4274 | 78.4% | |
| (Missing) | 204 | 3.7% |
| Max length | 28 |
|---|---|
| Mean length | 8.401099908 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
CO_ID
Numeric
| Distinct count | 262 |
|---|---|
| Unique (%) | 4.8% |
| Missing (%) | 63.6% |
| Missing (n) | 3471 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 19045.25958 |
|---|---|
| Minimum | 101 |
| Maximum | 23126 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 101 |
|---|---|
| 5-th percentile | 229 |
| Q1 | 18990 |
| Median | 19784 |
| Q3 | 19831 |
| 95-th percentile | 23091 |
| Maximum | 23126 |
| Range | 23025 |
| Interquartile range | 841 |
Descriptive statistics
| Standard deviation | 4708.155441 |
|---|---|
| Coef of variation | 0.247208783 |
| Kurtosis | 10.77882073 |
| Mean | 19045.25958 |
| MAD | 2282.585078 |
| Skewness | -3.308741099 |
| Sum | 37785795 |
| Variance | 22166727.66 |
| Memory size | 42.7 KiB |
| Value | Count | Frequency (%) | |
| 19808 | 83 | 1.5% | |
| 19784 | 72 | 1.3% | |
| 19797 | 55 | 1.0% | |
| 19806 | 50 | 0.9% | |
| 19831 | 49 | 0.9% | |
| 19817 | 47 | 0.9% | |
| 18065 | 31 | 0.6% | |
| 19822 | 30 | 0.5% | |
| 19809 | 30 | 0.5% | |
| 18013 | 29 | 0.5% | |
| Other values (251) | 1508 | 27.6% | |
| (Missing) | 3471 | 63.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 101 | 5 | 0.1% | |
| 104 | 3 | 0.1% | |
| 110 | 3 | 0.1% | |
| 114 | 2 | < 0.1% | |
| 118 | 1 | < 0.1% | |
| 121 | 1 | < 0.1% | |
| 127 | 1 | < 0.1% | |
| 130 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 23126 | 2 | < 0.1% | |
| 23124 | 7 | 0.1% | |
| 23123 | 3 | 0.1% | |
| 23122 | 5 | 0.1% | |
| 23117 | 14 | 0.3% | |
| 23111 | 2 | < 0.1% | |
| 23110 | 3 | 0.1% | |
| 23109 | 3 | 0.1% |
CO_MEMBER_TYPE
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 63.6% |
| Missing (n) | 3471 |
| CM | |
|---|---|
| NMC | 532 |
| PC | 40 |
| Other values (2) | 4 |
| (Missing) |
| Value | Count | Frequency (%) | |
| CM | 1408 | 25.8% | |
| NMC | 532 | 9.8% | |
| PC | 40 | 0.7% | |
| HOTEL | 3 | 0.1% | |
| HH | 1 | < 0.1% | |
| (Missing) | 3471 | 63.6% |
| Max length | 5 |
|---|---|
| Mean length | 2.735472044 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
COMPANY
Categorical
| Distinct count | 401 |
|---|---|
| Unique (%) | 7.4% |
| Missing (%) | 56.7% |
| Missing (n) | 3092 |
| Card Systems | 84 |
|---|---|
| Web Academy | 73 |
| Accessible Solutions Consulting | 56 |
| Other values (397) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| Card Systems | 84 | 1.5% | |
| Web Academy | 73 | 1.3% | |
| Accessible Solutions Consulting | 56 | 1.0% | |
| Acorn Specialties | 51 | 0.9% | |
| Red Banner Ambassadors | 50 | 0.9% | |
| Browning Systems | 47 | 0.9% | |
| Cokeson Partners | 31 | 0.6% | |
| Fountain Design, Inc | 31 | 0.6% | |
| Computer Products | 30 | 0.5% | |
| iMIS International | 30 | 0.5% | |
| Other values (390) | 1880 | 34.5% | |
| (Missing) | 3092 | 56.7% |
| Max length | 71 |
|---|---|
| Mean length | 9.875160403 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
COMPANY_RECORD
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 281 |
| Value | Count | Frequency (%) | |
| False | 5174 | 94.8% | |
| True | 281 | 5.2% |
COMPANY_SORT
Categorical
| Distinct count | 388 |
|---|---|
| Unique (%) | 7.1% |
| Missing (%) | 56.7% |
| Missing (n) | 3092 |
| CARD SYSTEMS | 84 |
|---|---|
| WEB ACADEMY | 73 |
| ACCESSIBLE SOLUTIONS CONSULTIN | 57 |
| Other values (384) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| CARD SYSTEMS | 84 | 1.5% | |
| WEB ACADEMY | 73 | 1.3% | |
| ACCESSIBLE SOLUTIONS CONSULTIN | 57 | 1.0% | |
| ACORN SPECIALTIES | 51 | 0.9% | |
| RED BANNER AMBASSADORS | 50 | 0.9% | |
| BROWNING SYSTEMS | 47 | 0.9% | |
| OPUS, INC. | 35 | 0.6% | |
| COKESON PARTNERS | 31 | 0.6% | |
| FOUNTAIN DESIGN, INC | 31 | 0.6% | |
| COMPUTER PRODUCTS | 30 | 0.5% | |
| Other values (377) | 1874 | 34.4% | |
| (Missing) | 3092 | 56.7% |
| Max length | 30 |
|---|---|
| Mean length | 9.540054995 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
CONTACT_RANK
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
COUNTRY
Categorical
| Distinct count | 19 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 3.8% |
| Missing (n) | 206 |
| United States | |
|---|---|
| United Kingdom | |
| Canada | |
| Other values (15) |
| Value | Count | Frequency (%) | |
| United States | 2511 | 46.0% | |
| United Kingdom | 1078 | 19.8% | |
| Canada | 773 | 14.2% | |
| Australia | 761 | 14.0% | |
| Singapore | 36 | 0.7% | |
| France | 15 | 0.3% | |
| Peru | 12 | 0.2% | |
| India | 11 | 0.2% | |
| New Zealand | 10 | 0.2% | |
| Malaysia | 9 | 0.2% | |
| Other values (8) | 33 | 0.6% | |
| (Missing) | 206 | 3.8% |
| Max length | 14 |
|---|---|
| Mean length | 11.13840513 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
COUNTY
Categorical
| Distinct count | 507 |
|---|---|
| Unique (%) | 9.3% |
| Missing (%) | 65.6% |
| Missing (n) | 3576 |
| Los Angeles | 102 |
|---|---|
| Dallas | 61 |
| Alexandria City | 53 |
| Other values (503) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| Los Angeles | 102 | 1.9% | |
| Dallas | 61 | 1.1% | |
| Alexandria City | 53 | 1.0% | |
| San Diego | 46 | 0.8% | |
| Cook | 37 | 0.7% | |
| Essex | 34 | 0.6% | |
| Harris | 28 | 0.5% | |
| Maricopa | 28 | 0.5% | |
| Travis | 26 | 0.5% | |
| Saginaw | 25 | 0.5% | |
| Other values (496) | 1439 | 26.4% | |
| (Missing) | 3576 | 65.6% |
| Max length | 20 |
|---|---|
| Mean length | 4.670210816 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
CRRT
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
DATE_ADDED
Date
| Distinct count | 156 |
|---|---|
| Unique (%) | 2.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 1992-08-10 00:00:00 |
|---|---|
| Maximum | 2018-01-13 00:00:00 |
DESIGNATION
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 99.5% |
| Missing (n) | 5429 |
| CPA | 12 |
|---|---|
| PhD | 2 |
| MBA | 2 |
| Other values (8) | 10 |
| (Missing) |
| Value | Count | Frequency (%) | |
| CPA | 12 | 0.2% | |
| PhD | 2 | < 0.1% | |
| MBA | 2 | < 0.1% | |
| M.D. | 2 | < 0.1% | |
| MD | 2 | < 0.1% | |
| LLB | 1 | < 0.1% | |
| MD, PhD | 1 | < 0.1% | |
| LLM | 1 | < 0.1% | |
| PhD. | 1 | < 0.1% | |
| CAPAE | 1 | < 0.1% | |
| (Missing) | 5429 | 99.5% |
| Max length | 7 |
|---|---|
| Mean length | 3.001283226 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
DISPLAY_CURRENCY
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
DUP_MATCH_KEY
Categorical
| Distinct count | 5387 |
|---|---|
| Unique (%) | 98.8% |
| Missing (%) | 0.1% |
| Missing (n) | 3 |
| 60601GUENJ | 10 |
|---|---|
| DAVI | 5 |
| MICH | 5 |
| Other values (5383) |
| Value | Count | Frequency (%) | |
| 60601GUENJ | 10 | 0.2% | |
| DAVI | 5 | 0.1% | |
| MICH | 5 | 0.1% | |
| MAHEJ | 4 | 0.1% | |
| ANDR | 4 | 0.1% | |
| MARK | 4 | 0.1% | |
| KEIT | 3 | 0.1% | |
| ROBE | 3 | 0.1% | |
| KATH | 3 | 0.1% | |
| KRIS | 3 | 0.1% | |
| Other values (5376) | 5408 | 99.1% |
| Max length | 10 |
|---|---|
| Mean length | 9.598533456 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
EMAIL
Categorical
| Distinct count | 4543 |
|---|---|
| Unique (%) | 83.3% |
| Missing (%) | 10.2% |
| Missing (n) | 556 |
| moreinfo@imisdemo.com | 8 |
|---|---|
| info@imisdemo.com | 7 |
| custserv@imisdemo.com | 7 |
| Other values (4539) | |
| (Missing) | 556 |
| Value | Count | Frequency (%) | |
| moreinfo@imisdemo.com | 8 | 0.1% | |
| info@imisdemo.com | 7 | 0.1% | |
| custserv@imisdemo.com | 7 | 0.1% | |
| jrguenther@bscichicago.com | 7 | 0.1% | |
| orders@imisdemo.com | 7 | 0.1% | |
| member@imisdemo.com | 6 | 0.1% | |
| help@imisdemo.com | 6 | 0.1% | |
| jbrown@imisdemo.com | 6 | 0.1% | |
| jjones@imisdemo.com | 5 | 0.1% | |
| tsmith@imisdemo.com | 5 | 0.1% | |
| Other values (4532) | 4835 | 88.6% | |
| (Missing) | 556 | 10.2% |
| Max length | 40 |
|---|---|
| Mean length | 19.03208066 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
EXCLUDE_DIRECTORY
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 1 |
| Value | Count | Frequency (%) | |
| False | 5454 | > 99.9% | |
| True | 1 | < 0.1% |
EXCLUDE_MAIL
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
FAX
Categorical
| Distinct count | 53 |
|---|---|
| Unique (%) | 1.0% |
| Missing (%) | 87.6% |
| Missing (n) | 4776 |
| (212) 556-3526 | 85 |
|---|---|
| (512) 344-9807 | 77 |
| (203) 984-8768 | 52 |
| Other values (49) | 465 |
| (Missing) |
| Value | Count | Frequency (%) | |
| (212) 556-3526 | 85 | 1.6% | |
| (512) 344-9807 | 77 | 1.4% | |
| (203) 984-8768 | 52 | 1.0% | |
| (713) 897-3459 | 51 | 0.9% | |
| (301) 526-3645 | 32 | 0.6% | |
| (317) 432-5565 | 31 | 0.6% | |
| (612) 657-4426 | 28 | 0.5% | |
| (214) 370-3447 | 27 | 0.5% | |
| (213) 624-5000 | 26 | 0.5% | |
| (201) 553-8999 | 24 | 0.4% | |
| Other values (42) | 246 | 4.5% | |
| (Missing) | 4776 | 87.6% |
| Max length | 14 |
|---|---|
| Mean length | 4.345004583 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
FIRST_NAME
Categorical
| Distinct count | 1224 |
|---|---|
| Unique (%) | 22.4% |
| Missing (%) | 6.8% |
| Missing (n) | 373 |
| James | 73 |
|---|---|
| John | 64 |
| David | 59 |
| Other values (1220) | |
| (Missing) | 373 |
| Value | Count | Frequency (%) | |
| James | 73 | 1.3% | |
| John | 64 | 1.2% | |
| David | 59 | 1.1% | |
| William | 53 | 1.0% | |
| Michael | 45 | 0.8% | |
| Charles | 44 | 0.8% | |
| Mary | 43 | 0.8% | |
| Robert | 39 | 0.7% | |
| Thomas | 32 | 0.6% | |
| Richard | 31 | 0.6% | |
| Other values (1213) | 4599 | 84.3% | |
| (Missing) | 373 | 6.8% |
| Max length | 14 |
|---|---|
| Mean length | 5.386617782 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
FULL_ADDRESS
Categorical
| Distinct count | 3229 |
|---|---|
| Unique (%) | 59.2% |
| Missing (%) | 3.0% |
| Missing (n) | 165 |
| 459 7th Ave-New York, NY 10001-2009-UNITED STATES | 84 |
|---|---|
| 1322C Central Parkway-Los Angeles, CA 92138-UNITED STATES | 67 |
| 2050 California Dr-Ripley, WV 25271-UNITED STATES | 56 |
| Other values (3225) | |
| (Missing) | 165 |
| Value | Count | Frequency (%) | |
| 459 7th Ave-New York, NY 10001-2009-UNITED STATES | 84 | 1.5% | |
| 1322C Central Parkway-Los Angeles, CA 92138-UNITED STATES | 67 | 1.2% | |
| 2050 California Dr-Ripley, WV 25271-UNITED STATES | 56 | 1.0% | |
| PO Box 9357-Indianapolis, IN 46202-UNITED STATES | 50 | 0.9% | |
| 10 High Street Laughton-567-SHEFFIELD-S25 1YF-UNITED KINGDOM | 50 | 0.9% | |
| Telford Crescent -Speedwell Industrial Estate-CHESTERFIELD-S43 3PF-UNITED KINGDOM | 41 | 0.8% | |
| 8439 Wisconsin Ave-Bethesda, MD 20814-3105-UNITED STATES | 31 | 0.6% | |
| 8910 Sylvan Rdg-Eden Prairie, MN 55347-3336-UNITED STATES | 30 | 0.5% | |
| Unit 23 Braden Industrial Estate-Worthing Road-SEVENOAKS-TN15 8DG-UNITED KINGDOM | 30 | 0.5% | |
| 4633 State Road 930-Fort Wayne, IN 46803-1613-UNITED STATES | 29 | 0.5% | |
| Other values (3218) | 4822 | 88.4% | |
| (Missing) | 165 | 3.0% |
| Max length | 95 |
|---|---|
| Mean length | 51.4731439 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
FULL_NAME
Categorical
| Distinct count | 5213 |
|---|---|
| Unique (%) | 95.6% |
| Missing (%) | 4.2% |
| Missing (n) | 228 |
| Jon Guenther | 12 |
|---|---|
| Joseph Maher | 3 |
| Timothy Alexander | 2 |
| Other values (5209) | |
| (Missing) | 228 |
| Value | Count | Frequency (%) | |
| Jon Guenther | 12 | 0.2% | |
| Joseph Maher | 3 | 0.1% | |
| Timothy Alexander | 2 | < 0.1% | |
| Mrs. Ebony O. Salvaire | 2 | < 0.1% | |
| Mrs. Caroline I. Bennett | 1 | < 0.1% | |
| Mr. Scott Yarbrough | 1 | < 0.1% | |
| Mr. Doug Bradford | 1 | < 0.1% | |
| Mr. Nicholas Graves | 1 | < 0.1% | |
| Mrs. Brittany Hammond | 1 | < 0.1% | |
| Ms. Ursula Eskola | 1 | < 0.1% | |
| Other values (5202) | 5202 | 95.4% | |
| (Missing) | 228 | 4.2% |
| Max length | 34 |
|---|---|
| Mean length | 17.50430797 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
FUNCTIONAL_TITLE
Categorical
| Distinct count | 9 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 99.7% |
| Missing (n) | 5441 |
| VP | 3 |
|---|---|
| CIO | 3 |
| CEO | 2 |
| Other values (5) | 6 |
| (Missing) |
| Value | Count | Frequency (%) | |
| VP | 3 | 0.1% | |
| CIO | 3 | 0.1% | |
| CEO | 2 | < 0.1% | |
| DPM | 2 | < 0.1% | |
| CFO | 1 | < 0.1% | |
| CTO | 1 | < 0.1% | |
| MGRDIR | 1 | < 0.1% | |
| Executive Director | 1 | < 0.1% | |
| (Missing) | 5441 | 99.7% |
| Max length | 18 |
|---|---|
| Mean length | 3.002749771 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
GENDER
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 21.0% |
| Missing (n) | 1148 |
| F | |
|---|---|
| M | |
| (Missing) |
| Value | Count | Frequency (%) | |
| F | 2295 | 42.1% | |
| M | 2012 | 36.9% | |
| (Missing) | 1148 | 21.0% |
| Max length | 3 |
|---|---|
| Mean length | 1.420898258 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
HOME_PHONE
Categorical
| Distinct count | 112 |
|---|---|
| Unique (%) | 2.1% |
| Missing (%) | 97.7% |
| Missing (n) | 5328 |
| (512) 565-9944 | 4 |
|---|---|
| (201) 786-5432 | 3 |
| (512) 875-6475 | 2 |
| Other values (108) | 118 |
| (Missing) |
| Value | Count | Frequency (%) | |
| (512) 565-9944 | 4 | 0.1% | |
| (201) 786-5432 | 3 | 0.1% | |
| (512) 875-6475 | 2 | < 0.1% | |
| (312) 553-6700 | 2 | < 0.1% | |
| (214) 659-7763 | 2 | < 0.1% | |
| (214) 675-8988 | 2 | < 0.1% | |
| (512) 098-7654 | 2 | < 0.1% | |
| (214) 233-7676 | 2 | < 0.1% | |
| (214) 678-9563 | 2 | < 0.1% | |
| (609) 456-7213 | 2 | < 0.1% | |
| Other values (101) | 104 | 1.9% | |
| (Missing) | 5328 | 97.7% |
| Max length | 14 |
|---|---|
| Mean length | 3.253895509 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
INFORMAL
Categorical
| Distinct count | 1185 |
|---|---|
| Unique (%) | 21.7% |
| Missing (%) | 7.5% |
| Missing (n) | 407 |
| James | 65 |
|---|---|
| John | 63 |
| David | 57 |
| Other values (1181) | |
| (Missing) | 407 |
| Value | Count | Frequency (%) | |
| James | 65 | 1.2% | |
| John | 63 | 1.2% | |
| David | 57 | 1.0% | |
| William | 52 | 1.0% | |
| Mary | 43 | 0.8% | |
| Michael | 42 | 0.8% | |
| Charles | 38 | 0.7% | |
| Robert | 35 | 0.6% | |
| Mark | 30 | 0.5% | |
| Karen | 29 | 0.5% | |
| Other values (1174) | 4594 | 84.2% | |
| (Missing) | 407 | 7.5% |
| Max length | 14 |
|---|---|
| Mean length | 5.275160403 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
INTENT_TO_EDIT
Categorical
| Distinct count | 58 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 99.0% |
| Missing (n) | 5398 |
| 11239917:24:38.00 | 1 |
|---|---|
| 11239916:09:46.00 | 1 |
| 11239916:13:17.00 | 1 |
| Other values (54) | 54 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 11239917:24:38.00 | 1 | < 0.1% | |
| 11239916:09:46.00 | 1 | < 0.1% | |
| 11239916:13:17.00 | 1 | < 0.1% | |
| 10290110:22:46.00 | 1 | < 0.1% | |
| 11239916:33:38.00 | 1 | < 0.1% | |
| 11239916:18:35.00 | 1 | < 0.1% | |
| 11239917:17:42.00 | 1 | < 0.1% | |
| 11239917:23:41.00 | 1 | < 0.1% | |
| 11239917:15:17.00 | 1 | < 0.1% | |
| 11239916:16:03.00 | 1 | < 0.1% | |
| Other values (47) | 47 | 0.9% | |
| (Missing) | 5398 | 99.0% |
| Max length | 17 |
|---|---|
| Mean length | 3.146287809 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
JOIN_DATE
Date
| Distinct count | 1860 |
|---|---|
| Unique (%) | 34.1% |
| Missing (%) | 15.5% |
| Missing (n) | 843 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 1965-05-02 00:00:00 |
|---|---|
| Maximum | 2016-08-11 00:00:00 |
LAST_FIRST
Categorical
| Distinct count | 5198 |
|---|---|
| Unique (%) | 95.3% |
| Missing (%) | 4.2% |
| Missing (n) | 228 |
| GUENTHER, JON | 12 |
|---|---|
| MAHER, JOSEPH | 3 |
| WILLIAMS, JOAN | 2 |
| Other values (5194) | |
| (Missing) | 228 |
| Value | Count | Frequency (%) | |
| GUENTHER, JON | 12 | 0.2% | |
| MAHER, JOSEPH | 3 | 0.1% | |
| WILLIAMS, JOAN | 2 | < 0.1% | |
| JONES, KAREN | 2 | < 0.1% | |
| SMITH, WILLIAM | 2 | < 0.1% | |
| MANLEY, TERRENCE | 2 | < 0.1% | |
| GILBERT, KELLY | 2 | < 0.1% | |
| TIMOTHY ALEXANDER | 2 | < 0.1% | |
| JACKSON, DAVID | 2 | < 0.1% | |
| WILLIAMS, BRUCE | 2 | < 0.1% | |
| Other values (5187) | 5196 | 95.3% | |
| (Missing) | 228 | 4.2% |
| Max length | 26 |
|---|---|
| Mean length | 13.50797434 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
LAST_NAME
Categorical
| Distinct count | 3022 |
|---|---|
| Unique (%) | 55.4% |
| Missing (%) | 4.3% |
| Missing (n) | 232 |
| Smith | 54 |
|---|---|
| Johnson | 45 |
| Williams | 40 |
| Other values (3018) | |
| (Missing) | 232 |
| Value | Count | Frequency (%) | |
| Smith | 54 | 1.0% | |
| Johnson | 45 | 0.8% | |
| Williams | 40 | 0.7% | |
| Brown | 37 | 0.7% | |
| Jones | 29 | 0.5% | |
| Taylor | 20 | 0.4% | |
| Miller | 18 | 0.3% | |
| White | 17 | 0.3% | |
| Davis | 17 | 0.3% | |
| Green | 16 | 0.3% | |
| Other values (3011) | 4930 | 90.4% | |
| (Missing) | 232 | 4.3% |
| Max length | 24 |
|---|---|
| Mean length | 6.467277727 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
LAST_UPDATED
Date
| Distinct count | 3970 |
|---|---|
| Unique (%) | 72.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 2001-02-19 14:04:00 |
|---|---|
| Maximum | 2018-01-13 18:13:03.927000 |
MAIL_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
MAJOR_KEY
Numeric
| Distinct count | 4944 |
|---|---|
| Unique (%) | 90.6% |
| Missing (%) | 9.3% |
| Missing (n) | 509 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13136.75455 |
|---|---|
| Minimum | 101 |
| Maximum | 123456 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 101 |
|---|---|
| 5-th percentile | 10195.25 |
| Q1 | 11186.25 |
| Median | 12423.5 |
| Q3 | 15224.25 |
| 95-th percentile | 17609 |
| Maximum | 123456 |
| Range | 123355 |
| Interquartile range | 4038 |
Descriptive statistics
| Standard deviation | 3285.360453 |
|---|---|
| Coef of variation | 0.2500892013 |
| Kurtosis | 264.7622493 |
| Mean | 13136.75455 |
| MAD | 2272.356082 |
| Skewness | 7.431161471 |
| Sum | 64974388 |
| Variance | 10793593.3 |
| Memory size | 42.7 KiB |
| Value | Count | Frequency (%) | |
| 17966 | 2 | < 0.1% | |
| 10009 | 2 | < 0.1% | |
| 12428 | 2 | < 0.1% | |
| 12047 | 1 | < 0.1% | |
| 10067 | 1 | < 0.1% | |
| 17547 | 1 | < 0.1% | |
| 15298 | 1 | < 0.1% | |
| 11029 | 1 | < 0.1% | |
| 11446 | 1 | < 0.1% | |
| 12954 | 1 | < 0.1% | |
| Other values (4933) | 4933 | 90.4% | |
| (Missing) | 509 | 9.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 101 | 1 | < 0.1% | |
| 104 | 1 | < 0.1% | |
| 105 | 1 | < 0.1% | |
| 107 | 1 | < 0.1% | |
| 108 | 1 | < 0.1% | |
| 109 | 1 | < 0.1% | |
| 110 | 1 | < 0.1% | |
| 111 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 123456 | 1 | < 0.1% | |
| 56634 | 1 | < 0.1% | |
| 17992 | 1 | < 0.1% | |
| 17986 | 1 | < 0.1% | |
| 17985 | 1 | < 0.1% | |
| 17981 | 1 | < 0.1% | |
| 17980 | 1 | < 0.1% | |
| 17979 | 1 | < 0.1% |
MEMBER_RECORD
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 2743 | 50.3% | |
| True | 2712 | 49.7% |
MEMBER_STATUS
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 50.1% |
| Missing (n) | 2733 |
| R | |
|---|---|
| N | 536 |
| D | 43 |
| Other values (2) | 54 |
| (Missing) |
| Value | Count | Frequency (%) | |
| R | 2089 | 38.3% | |
| N | 536 | 9.8% | |
| D | 43 | 0.8% | |
| I | 41 | 0.8% | |
| S | 13 | 0.2% | |
| (Missing) | 2733 | 50.1% |
| Max length | 3 |
|---|---|
| Mean length | 2.002016499 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
MEMBER_STATUS_DATE
Date
| Distinct count | 360 |
|---|---|
| Unique (%) | 6.6% |
| Missing (%) | 51.1% |
| Missing (n) | 2786 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 1901-04-08 00:00:00 |
|---|---|
| Maximum | 2017-08-01 00:00:00 |
MEMBER_TYPE
Categorical
| Distinct count | 19 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| M | |
|---|---|
| NM | |
| D | 427 |
| Other values (16) |
| Value | Count | Frequency (%) | |
| M | 2403 | 44.1% | |
| NM | 1780 | 32.6% | |
| D | 427 | 7.8% | |
| P | 292 | 5.4% | |
| CM | 185 | 3.4% | |
| NMC | 85 | 1.6% | |
| ASI | 73 | 1.3% | |
| PART | 72 | 1.3% | |
| STF | 58 | 1.1% | |
| A | 27 | 0.5% | |
| Other values (9) | 53 | 1.0% |
| Max length | 5 |
|---|---|
| Mean length | 1.503024748 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
MIDDLE_NAME
Categorical
| Distinct count | 98 |
|---|---|
| Unique (%) | 1.8% |
| Missing (%) | 54.9% |
| Missing (n) | 2995 |
| L. | 121 |
|---|---|
| K. | 121 |
| E. | 120 |
| Other values (94) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| L. | 121 | 2.2% | |
| K. | 121 | 2.2% | |
| E. | 120 | 2.2% | |
| F. | 118 | 2.2% | |
| N. | 117 | 2.1% | |
| G. | 115 | 2.1% | |
| J. | 110 | 2.0% | |
| H. | 110 | 2.0% | |
| A. | 105 | 1.9% | |
| P. | 100 | 1.8% | |
| Other values (87) | 1323 | 24.3% | |
| (Missing) | 2995 | 54.9% |
| Max length | 9 |
|---|---|
| Mean length | 2.606232814 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
MOBILE_PHONE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.8% |
| Missing (n) | 5446 |
| (312) 498-3885 | 9 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| (312) 498-3885 | 9 | 0.2% | |
| (Missing) | 5446 | 99.8% |
| Max length | 14 |
|---|---|
| Mean length | 3.018148488 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
MT_CHANGE_DATE
Date
| Distinct count | 186 |
|---|---|
| Unique (%) | 3.4% |
| Missing (%) | 95.4% |
| Missing (n) | 5203 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 1994-12-04 00:00:00 |
|---|---|
| Maximum | 2017-06-12 14:26:36 |
ORG_CODE
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.1% |
| Missing (n) | 4 |
| DEMO | |
|---|---|
| ORG1 | 33 |
| NAE | 1 |
| Other values (2) | 2 |
| (Missing) | 4 |
| Value | Count | Frequency (%) | |
| DEMO | 5415 | 99.3% | |
| ORG1 | 33 | 0.6% | |
| NAE | 1 | < 0.1% | |
| GEO | 1 | < 0.1% | |
| GSTIN | 1 | < 0.1% | |
| (Missing) | 4 | 0.1% |
| Max length | 5 |
|---|---|
| Mean length | 3.99908341 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
PAID_THRU
Categorical
| Distinct count | 48 |
|---|---|
| Unique (%) | 0.9% |
| Missing (%) | 54.3% |
| Missing (n) | 2963 |
| 2011-12-30 | |
|---|---|
| 2012-03-30 | 340 |
| 2017-12-31 | 258 |
| Other values (44) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 2011-12-30 | 1148 | 21.0% | |
| 2012-03-30 | 340 | 6.2% | |
| 2017-12-31 | 258 | 4.7% | |
| 2010-12-30 | 225 | 4.1% | |
| 2011-03-30 | 108 | 2.0% | |
| 2012-06-30 | 100 | 1.8% | |
| 2012-02-28 | 53 | 1.0% | |
| 2011-11-28 | 38 | 0.7% | |
| 2001-03-30 | 28 | 0.5% | |
| 2011-09-30 | 23 | 0.4% | |
| Other values (37) | 171 | 3.1% | |
| (Missing) | 2963 | 54.3% |
| Max length | 19 |
|---|---|
| Mean length | 6.656095325 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
PartyId
Highly correlated
This variable is highly correlated with BT_ID and should be ignored for analysis
| Correlation | 1 |
|---|
PREFIX
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 16.2% |
| Missing (n) | 884 |
| Mr. | |
|---|---|
| Ms. | |
| Mrs. | |
| Other values (10) | 167 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Mr. | 2063 | 37.8% | |
| Ms. | 1680 | 30.8% | |
| Mrs. | 661 | 12.1% | |
| Miss | 65 | 1.2% | |
| Dr. | 44 | 0.8% | |
| Rev. | 21 | 0.4% | |
| Hon. | 14 | 0.3% | |
| Pastor | 12 | 0.2% | |
| Lieutenant Colonel | 4 | 0.1% | |
| Ms | 3 | 0.1% | |
| Other values (3) | 4 | 0.1% | |
| (Missing) | 884 | 16.2% |
| Max length | 18 |
|---|---|
| Mean length | 3.157286893 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
PREVIOUS_MT
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 95.4% |
| Missing (n) | 5203 |
| NM | 84 |
|---|---|
| STF | 68 |
| M | 44 |
| Other values (10) | 56 |
| (Missing) |
| Value | Count | Frequency (%) | |
| NM | 84 | 1.5% | |
| STF | 68 | 1.2% | |
| M | 44 | 0.8% | |
| NMC | 16 | 0.3% | |
| CM | 13 | 0.2% | |
| A | 10 | 0.2% | |
| D | 5 | 0.1% | |
| P | 5 | 0.1% | |
| APPL | 3 | 0.1% | |
| RET | 1 | < 0.1% | |
| Other values (3) | 3 | 0.1% | |
| (Missing) | 5203 | 95.4% |
| Max length | 4 |
|---|---|
| Mean length | 2.959486709 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
SIC_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
SOURCE_CODE
Categorical
| Distinct count | 4946 |
|---|---|
| Unique (%) | 90.7% |
| Missing (%) | 9.3% |
| Missing (n) | 510 |
| uk_final_export_14803 | 1 |
|---|---|
| usa_final_export_10058 | 1 |
| usa_final_export_10167 | 1 |
| Other values (4942) | |
| (Missing) | 510 |
| Value | Count | Frequency (%) | |
| uk_final_export_14803 | 1 | < 0.1% | |
| usa_final_export_10058 | 1 | < 0.1% | |
| usa_final_export_10167 | 1 | < 0.1% | |
| aus_final_export_17328 | 1 | < 0.1% | |
| canada_final_Export_13607 | 1 | < 0.1% | |
| usa_final_export_10774 | 1 | < 0.1% | |
| usa_final_export_10568 | 1 | < 0.1% | |
| canada_final_Export_14540 | 1 | < 0.1% | |
| uk_final_export_14921 | 1 | < 0.1% | |
| usa_final_export_11192 | 1 | < 0.1% | |
| Other values (4935) | 4935 | 90.5% | |
| (Missing) | 510 | 9.3% |
| Max length | 25 |
|---|---|
| Mean length | 20.44601283 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
STATE_HOUSE
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
STATE_PROVINCE
Categorical
| Distinct count | 138 |
|---|---|
| Unique (%) | 2.5% |
| Missing (%) | 9.3% |
| Missing (n) | 508 |
| ON | 332 |
|---|---|
| CA | 314 |
| TX | 292 |
| Other values (134) | |
| (Missing) | 508 |
| Value | Count | Frequency (%) | |
| ON | 332 | 6.1% | |
| CA | 314 | 5.8% | |
| TX | 292 | 5.4% | |
| WA | 175 | 3.2% | |
| NY | 170 | 3.1% | |
| VIC | 164 | 3.0% | |
| BC | 156 | 2.9% | |
| PA | 127 | 2.3% | |
| QLD | 127 | 2.3% | |
| SA | 121 | 2.2% | |
| Other values (127) | 2969 | 54.4% | |
| (Missing) | 508 | 9.3% |
| Max length | 15 |
|---|---|
| Mean length | 3.362053162 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
STATE_SENATE
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
STATUS
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| A | |
|---|---|
| D | 7 |
| I | 2 |
| Value | Count | Frequency (%) | |
| A | 5446 | 99.8% | |
| D | 7 | 0.1% | |
| I | 2 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
SUFFIX
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 99.7% |
| Missing (n) | 5436 |
| Jr. | 12 |
|---|---|
| III | 4 |
| Sr. | 3 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Jr. | 12 | 0.2% | |
| III | 4 | 0.1% | |
| Sr. | 3 | 0.1% | |
| (Missing) | 5436 | 99.7% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
TITLE
Categorical
| Distinct count | 195 |
|---|---|
| Unique (%) | 3.6% |
| Missing (%) | 93.6% |
| Missing (n) | 5107 |
| President | 30 |
|---|---|
| Vice President | 15 |
| Sales Manager | 11 |
| Other values (191) | 292 |
| (Missing) |
| Value | Count | Frequency (%) | |
| President | 30 | 0.5% | |
| Vice President | 15 | 0.3% | |
| Sales Manager | 11 | 0.2% | |
| Branch Manager | 10 | 0.2% | |
| CEO | 7 | 0.1% | |
| Office Manager | 6 | 0.1% | |
| Director | 6 | 0.1% | |
| Accountant | 6 | 0.1% | |
| Team Lead | 6 | 0.1% | |
| Controller | 6 | 0.1% | |
| Other values (184) | 245 | 4.5% | |
| (Missing) | 5107 | 93.6% |
| Max length | 38 |
|---|---|
| Mean length | 3.777818515 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
TOLL_FREE
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 99.2% |
| Missing (n) | 5414 |
| (800) 433-8900 | 27 |
|---|---|
| (800) 9HILTON | 8 |
| (800) 984-0000 | 3 |
| Other values (2) | 3 |
| (Missing) |
| Value | Count | Frequency (%) | |
| (800) 433-8900 | 27 | 0.5% | |
| (800) 9HILTON | 8 | 0.1% | |
| (800) 984-0000 | 3 | 0.1% | |
| (800) 123-4567 | 2 | < 0.1% | |
| (180) 043-3890 | 1 | < 0.1% | |
| (Missing) | 5414 | 99.2% |
| Max length | 14 |
|---|---|
| Mean length | 3.081209899 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
UPDATED_BY
Categorical
| Distinct count | 48 |
|---|---|
| Unique (%) | 0.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| BRIANP | |
|---|---|
| BRIANM | |
| BSCHRADER | 432 |
| Other values (45) | 415 |
| Value | Count | Frequency (%) | |
| BRIANP | 3336 | 61.2% | |
| BRIANM | 1272 | 23.3% | |
| BSCHRADER | 432 | 7.9% | |
| MANAGER | 186 | 3.4% | |
| FADMIN | 78 | 1.4% | |
| CHARLOTTE | 36 | 0.7% | |
| BMURPHY | 26 | 0.5% | |
| 217 | 12 | 0.2% | |
| CROBERTSON | 11 | 0.2% | |
| 18106 | 9 | 0.2% | |
| Other values (38) | 57 | 1.0% |
| Max length | 27 |
|---|---|
| Mean length | 6.337121907 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
US_CONGRESS
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
WEBSITE
Categorical
| Distinct count | 79 |
|---|---|
| Unique (%) | 1.4% |
| Missing (%) | 91.2% |
| Missing (n) | 4977 |
| versaton.imisdemo.com | 30 |
|---|---|
| www.prodigy.com | 23 |
| www.bachmanfloral.com | 20 |
| Other values (75) | 405 |
| (Missing) |
| Value | Count | Frequency (%) | |
| versaton.imisdemo.com | 30 | 0.5% | |
| www.prodigy.com | 23 | 0.4% | |
| www.bachmanfloral.com | 20 | 0.4% | |
| www.imisdemo.com | 20 | 0.4% | |
| www.century21.ca/vancouver | 18 | 0.3% | |
| www.couturier.com.ca | 16 | 0.3% | |
| www.nhq.org | 16 | 0.3% | |
| www.regina.com.ca | 15 | 0.3% | |
| www.lakeviewtravel.com.ca | 15 | 0.3% | |
| www.opusisus.com | 14 | 0.3% | |
| Other values (68) | 291 | 5.3% | |
| (Missing) | 4977 | 91.2% |
| Max length | 48 |
|---|---|
| Mean length | 4.560953254 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
WORK_PHONE
Categorical
| Distinct count | 2775 |
|---|---|
| Unique (%) | 50.9% |
| Missing (%) | 13.1% |
| Missing (n) | 716 |
| 08704887700 | 110 |
|---|---|
| (212) 556-7489 | 85 |
| (512) 344-5687 | 76 |
| Other values (2771) | |
| (Missing) | 716 |
| Value | Count | Frequency (%) | |
| 08704887700 | 110 | 2.0% | |
| (212) 556-7489 | 85 | 1.6% | |
| (512) 344-5687 | 76 | 1.4% | |
| (214) 987-8765 | 62 | 1.1% | |
| 020 8243 0564 | 57 | 1.0% | |
| (516) 987-2222 | 43 | 0.8% | |
| (301) 526-8795 | 32 | 0.6% | |
| (317) 432-5560 | 31 | 0.6% | |
| 08207887700 | 30 | 0.5% | |
| (312) 333-4450 | 28 | 0.5% | |
| Other values (2764) | 4185 | 76.7% | |
| (Missing) | 716 | 13.1% |
| Max length | 24 |
|---|---|
| Mean length | 12.53418882 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
ZIP
Categorical
| Distinct count | 3008 |
|---|---|
| Unique (%) | 55.1% |
| Missing (%) | 3.7% |
| Missing (n) | 202 |
| 10001-2009 | 85 |
|---|---|
| 92138 | 67 |
| 25271 | 56 |
| Other values (3004) | |
| (Missing) | 202 |
| Value | Count | Frequency (%) | |
| 10001-2009 | 85 | 1.6% | |
| 92138 | 67 | 1.2% | |
| 25271 | 56 | 1.0% | |
| S25 1YF | 50 | 0.9% | |
| 46202 | 50 | 0.9% | |
| S43 3PF | 48 | 0.9% | |
| 5000 | 47 | 0.9% | |
| 7000 | 38 | 0.7% | |
| 78759 | 34 | 0.6% | |
| 55347-3336 | 31 | 0.6% | |
| Other values (2997) | 4747 | 87.0% | |
| (Missing) | 202 | 3.7% |
| Max length | 10 |
|---|---|
| Mean length | 7.367736022 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
First rows
| BAR_CODE | BIRTH_DATE | BT_ID | CATEGORY | CHAPTER | CITY | CO_ID | CO_MEMBER_TYPE | COMPANY | COMPANY_RECORD | COMPANY_SORT | CONTACT_RANK | COUNTRY | COUNTY | CRRT | DATE_ADDED | DESIGNATION | DISPLAY_CURRENCY | DUP_MATCH_KEY | EXCLUDE_DIRECTORY | EXCLUDE_MAIL | FAX | FIRST_NAME | FULL_ADDRESS | FULL_NAME | FUNCTIONAL_TITLE | GENDER | HOME_PHONE | INFORMAL | INTENT_TO_EDIT | JOIN_DATE | LAST_FIRST | LAST_NAME | LAST_UPDATED | MAIL_CODE | MAJOR_KEY | MEMBER_RECORD | MEMBER_STATUS | MEMBER_STATUS_DATE | MEMBER_TYPE | MIDDLE_NAME | MOBILE_PHONE | MT_CHANGE_DATE | ORG_CODE | PAID_THRU | PartyId | PREFIX | PREVIOUS_MT | SIC_CODE | SOURCE_CODE | STATE_HOUSE | STATE_PROVINCE | STATE_SENATE | STATUS | SUFFIX | TITLE | TOLL_FREE | UPDATED_BY | US_CONGRESS | WEBSITE | WORK_PHONE | ZIP | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | 1950-04-21 | NaN | NaN | NaN | Newark | NaN | NaN | Prodigy Makers International | True | PRODIGY MAKERS INTERNATIONAL | 0 | United States | NaN | NaN | 1994-11-27 00:00:00.000 | NaN | NaN | 07107HUNTD | jrguenther@bscichicago.com | False | False | (201) 898-4255 | Douglas | P.O. Box 4564-Newark, NJ 07107-2564-UNITED ST... | Mr. Douglas A. Hunt, Jr. | NaN | M | (201) 346-9989 | Doug | 03060017:56:10.00 | 1965-05-02 | HUNT, DOUGLAS | Hunt | 2016-06-17 11:09:11.000 | NaN | NaN | True | R | 2016-08-09 00:00:00 | CM | A. | NaN | NaT | ORG1 | 2017-03-31T00:00:00 | 101 | Mr. | NaN | NaN | NaN | NaN | NJ | NaN | A | Jr. | President | NaN | MANAGER | NaN | NaN | (201) 898-9000 | 07107-2564 |
| 1 | NaN | NaT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | False | NaN | 0 | NaN | NaN | NaN | 2008-05-27 10:38:51.000 | NaN | NaN | NaN | NaN | False | False | NaN | NUNIT1 | NaN | NUNIT1 | NaN | NaN | NaN | NaN | NaN | NaT | NUNIT1 | NaN | 2008-05-27 10:38:51.000 | NaN | NaN | False | NaN | NaT | NM | NaN | NaN | NaT | NaN | NaN | 103 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | A | NaN | NaN | NaN | BSCHRADER | NaN | NaN | NaN | NaN |
| 2 | NaN | 1950-05-03 | NaN | 1 | NaN | Somerville | NaN | NaN | Foundation Support Systems | True | FOUNDATION SUPPORT SYSTEMS | 0 | United States | NaN | NaN | 1992-08-10 00:00:00.000 | PhD. | NaN | 88760CORWC | NaN | False | False | (201) 543-6785 | Charles | 150 Highway 202-Somerville, NJ 88760-UNITED S... | Dr. Charles R. Corwin, PhD. | NaN | NaN | (201) 456-8903 | Chuck | 11239917:13:29.00 | 1970-05-03 | CORWIN, CHARLES | Corwin | 2014-07-15 16:35:05.490 | NaN | NaN | True | R | 1998-03-04 00:00:00 | CM | R. | NaN | 1994-12-04 00:00:00.000 | ORG1 | 2001-03-30 | 104 | Dr. | NM | NaN | NaN | NaN | NJ | NaN | A | NaN | President | NaN | BRIANM | NaN | NaN | (201) 245-6754 | 88760 |
| 3 | /0887612459/ | NaT | NaN | NaN | WEST | Somerville | 104.0 | CM | Foundation Support Systems | False | FOUNDATION SUPPORT SYSTEMS | 0 | NaN | NaN | NaN | 1992-08-10 00:00:00.000 | NaN | NaN | 08876HAMIC | carolhamilton@imisdemo.com | False | False | (201) 543-6785 | Carol | P.O. Box 472665-Somerville, NJ 08876-1245 | Ms. Carol A. Hamilton | NaN | F | (201) 786-5432 | Carol | 11239916:39:15.00 | 1990-05-03 | HAMILTON, CAROL | Hamilton | 2014-10-17 15:55:47.027 | NaN | NaN | True | R | 1998-01-04 00:00:00 | M | A. | NaN | NaT | ORG1 | 2001-03-30 | 105 | Ms. | NaN | NaN | NaN | NaN | NJ | NaN | A | NaN | Administrative Assistant | NaN | BRIANM | NaN | NaN | (201) 245-6754 | 08876-1245 |
| 4 | /2584014042/ | NaT | NaN | NaN | WEST | Fayetteville | 19751.0 | PC | Berry Ltd. | False | BERRY LTD. | 0 | United States | Fayette | NaN | 2007-10-17 18:12:30.730 | NaN | NaN | 25840PANDJ | jpandit@imisdemo.com | False | False | NaN | Jai | 184 Allen St-Fayetteville, WV 25840-1404-UNIT... | Jai Pandit | NaN | NaN | NaN | Jai | NaN | NaT | PANDIT, JAI | Pandit | 2014-04-16 16:59:53.000 | NaN | NaN | True | N | 2007-10-17 18:12:31 | M | NaN | NaN | NaT | DEMO | 2017-12-31 | 106 | NaN | NaN | NaN | NaN | NaN | WV | NaN | A | NaN | NaN | NaN | BSCHRADER | NaN | NaN | (304) 555-1602 | 25840-1404 |
| 5 | NaN | NaT | NaN | 1 | NaN | Dallas | 159.0 | CM | Acme, Inc. | False | ACME, INC. | 0 | United States | NaN | NaN | 1992-08-22 00:00:00.000 | CPA | NaN | 75201CALLP | paulacaller@imisdemo.com | False | False | NaN | Paula | 1700 Atlantic Avenue-Dallas, TX 75201-4620-UN... | Ms. Paula D. Caller, CPA | NaN | F | (214) 749-9849 | Paula | 08210011:24:47.00 | 1990-04-01 | CALLER, PAULA | Caller | 2014-07-15 16:35:05.490 | NaN | NaN | True | R | 1998-02-04 00:00:00 | M | D. | NaN | 1994-12-04 00:00:00.000 | ORG1 | 2001-03-30 | 107 | Ms. | M | NaN | NaN | NaN | TX | NaN | A | NaN | Controller | NaN | BRIANM | NaN | NaN | (214) 987-8765 | 75201-4620 |
| 6 | NaN | NaT | NaN | 1 | NaN | Dallas | 159.0 | CM | Acme, Inc. | False | ACME, INC. | 0 | United States | NaN | NaN | 1992-08-10 00:00:00.000 | NaN | NaN | 75201COOKD | NaN | False | False | NaN | David | 1700 Atlantic Avenue-Dallas, TX 75201-4620-UN... | Mr. David F. Cooke, Jr. | NaN | M | (214) 659-7763 | Dave | 11239916:04:36.00 | 1990-06-01 | COOKE, DAVID | Cooke | 2014-07-15 16:35:05.490 | NaN | NaN | True | R | 1998-04-01 00:00:00 | M | F. | NaN | 1994-12-04 00:00:00.000 | ORG1 | 2001-05-28 | 108 | Mr. | NM | NaN | NaN | NaN | TX | NaN | A | Jr. | Vice President | NaN | BRIANM | NaN | NaN | (214) 987-8765 | 75201-4620 |
| 7 | NaN | NaT | NaN | 1 | NaN | Deakin | NaN | NaN | Office Supplies, Inc. | True | OFFICE SUPPLIES, INC. | 0 | Australia | NaN | NaN | 1992-08-10 00:00:00.000 | NaN | NaN | 2600TREEJ | NaN | False | False | NaN | John | 61 Napier Close-Deakin, ACT 2600-AUSTRALIA | Mr. John G. Tree, Sr. | NaN | M | (214) 727-5523 | John | 11239916:16:21.00 | 1983-05-01 | TREE, JOHN | Tree | 2014-07-15 16:35:05.490 | NaN | NaN | True | R | 1998-04-20 00:00:00 | CM | G. | NaN | 2014-10-15 16:35:05.490 | ORG1 | 2001-04-30 | 109 | Mr. | A | NaN | NaN | NaN | ACT | NaN | A | Sr. | Sales Manager | NaN | BRIANM | NaN | NaN | (028) 893-2326 | 2600 |
| 8 | NaN | 1941-07-04 | NaN | 1 | NaN | Dallas | NaN | NaN | Sailing Dreams, Inc. | True | SAILING DREAMS, INC. | 0 | United States | NaN | NaN | 1992-08-15 00:00:00.000 | NaN | NaN | 75208COURW | NaN | False | False | (214) 222-1115 | Wayne | 205 W. Commerce-Dallas, TX 75208-UNITED STATES | Mr. Wayne Courtland | NaN | M | (214) 675-8988 | Wayne | 11239917:14:06.00 | 1974-08-15 | COURTLAND, WAYNE | Courtland | 2014-07-15 16:35:05.490 | NaN | NaN | True | R | 1998-03-01 00:00:00 | CM | NaN | NaN | NaT | ORG1 | 2001-03-30 | 110 | Mr. | NaN | NaN | NaN | NaN | TX | NaN | A | NaN | President | NaN | BRIANM | NaN | NaN | (214) 445-6734 | 75208 |
| 9 | /7520687654/ | NaT | NaN | NaN | NaN | Dallas | 110.0 | CM | Sailing Dreams, Inc. | False | SAILING DREAMS, INC. | 0 | NaN | NaN | NaN | 1992-08-10 00:00:00.000 | NaN | NaN | 75206HARRR | NaN | False | False | (214) 222-1115 | Richard | P.O. Box 8765-Dallas, TX 75206-8765 | Mr. Richard B. Harris | NaN | M | (214) 233-7676 | Dick | 11239916:09:22.00 | 1990-07-01 | HARRIS, RICHARD | Harris | 2001-02-23 16:09:00.000 | NaN | NaN | True | R | 1998-07-15 00:00:00 | M | B. | NaN | 1994-12-04 00:00:00.000 | ORG1 | 2001-12-30 | 111 | Mr. | NM | NaN | NaN | NaN | TX | NaN | A | NaN | Administrative Manager | NaN | MANAGER | NaN | NaN | (214) 445-6734, Ext. 20 | 75206-8765 |
Last rows
| BAR_CODE | BIRTH_DATE | BT_ID | CATEGORY | CHAPTER | CITY | CO_ID | CO_MEMBER_TYPE | COMPANY | COMPANY_RECORD | COMPANY_SORT | CONTACT_RANK | COUNTRY | COUNTY | CRRT | DATE_ADDED | DESIGNATION | DISPLAY_CURRENCY | DUP_MATCH_KEY | EXCLUDE_DIRECTORY | EXCLUDE_MAIL | FAX | FIRST_NAME | FULL_ADDRESS | FULL_NAME | FUNCTIONAL_TITLE | GENDER | HOME_PHONE | INFORMAL | INTENT_TO_EDIT | JOIN_DATE | LAST_FIRST | LAST_NAME | LAST_UPDATED | MAIL_CODE | MAJOR_KEY | MEMBER_RECORD | MEMBER_STATUS | MEMBER_STATUS_DATE | MEMBER_TYPE | MIDDLE_NAME | MOBILE_PHONE | MT_CHANGE_DATE | ORG_CODE | PAID_THRU | PartyId | PREFIX | PREVIOUS_MT | SIC_CODE | SOURCE_CODE | STATE_HOUSE | STATE_PROVINCE | STATE_SENATE | STATUS | SUFFIX | TITLE | TOLL_FREE | UPDATED_BY | US_CONGRESS | WEBSITE | WORK_PHONE | ZIP | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5445 | NaN | NaT | NaN | NaN | SOUTH | Southampton | 18149.0 | CM | Glover International | False | GLOVER INTERNATIONAL | 0 | United Kingdom | NaN | NaN | 2009-11-25 00:00:00.000 | NaN | NaN | SO30 STAFT | NaN | False | False | NaN | Tessa | Botley Mills-Botley-SOUTHAMPTON-SO30 2GB-UNITE... | Tessa Stafford | NaN | NaN | NaN | Tessa | NaN | NaT | STAFFORD, TESSA | Stafford | 2014-07-25 15:22:20.720 | NaN | NaN | True | N | 2009-11-25 | M | NaN | NaN | NaT | DEMO | 2017-12-31 | 254 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | A | NaN | NaN | NaN | BRIANM | NaN | NaN | 44-1489-885 000 | SO30 2GB |
| 5446 | NaN | NaT | NaN | NaN | WEST | Paris | 18077.0 | CM | Opus Europe | False | OPUS EUROPE | 0 | France | NaN | NaN | 2010-01-10 00:00:00.000 | NaN | NaN | 3499COWLD | NaN | False | False | NaN | David | 1322 Champs lys es-3499 PARIS-FRANCE | David Cowlings | NaN | NaN | NaN | Dave | NaN | NaT | COWLINGS, DAVID | Cowlings | 2014-07-25 15:22:20.720 | NaN | NaN | True | N | 2010-01-10 | M | NaN | NaN | NaT | DEMO | 2017-12-31 | 255 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | A | NaN | NaN | NaN | BRIANM | NaN | NaN | 011.33.49.22.22.22 | 3499 |
| 5447 | NaN | NaT | NaN | NaN | NaN | Ripley | 19797.0 | CM | Accessible Solutions Consulting | False | ACCESSIBLE SOLUTIONS CONSULTIN | 0 | United States | NaN | NaN | 2010-02-10 00:00:00.000 | NaN | NaN | ROMAJ | jromansen@imisdemo.com | False | False | NaN | John | 2050 California Dr-Ripley, WV 25271-UNITED ST... | John Romansen | NaN | NaN | NaN | John | NaN | NaT | ROMANSEN, JOHN | Romansen | 2014-07-25 15:22:20.720 | NaN | NaN | True | N | 2010-02-10 | M | NaN | NaN | NaT | DEMO | 2017-12-31 | 256 | NaN | NaN | NaN | NaN | NaN | WV | NaN | A | NaN | NaN | NaN | BRIANM | NaN | NaN | (214) 987-8765 | 25271 |
| 5448 | NaN | NaT | NaN | NaN | NaN | Austin | 229.0 | CM | Creative Distractions | False | CREATIVE DISTRACTIONS | 0 | United States | NaN | NaN | 2010-03-09 00:00:00.000 | NaN | NaN | 78759ACEVF | francisacevedo@imisdemo.com | False | False | NaN | Francis | 11044 Research Blvd.-Building B, Suite 300-Aus... | Francis Acevedo | NaN | NaN | NaN | Francis | NaN | NaT | ACEVEDO, FRANCIS | Acevedo | 2014-11-03 15:17:24.343 | NaN | NaN | True | N | 2010-03-09 | M | NaN | NaN | NaT | DEMO | 2017-12-31 | 257 | NaN | NaN | NaN | NaN | NaN | TX | NaN | A | NaN | Sr, Supervisor | NaN | BRIANM | NaN | NaN | NaN | 78759 |
| 5449 | NaN | NaT | NaN | NaN | NaN | Austin | 229.0 | CM | Creative Distractions | False | CREATIVE DISTRACTIONS | 0 | United States | NaN | NaN | 2010-03-09 00:00:00.000 | NaN | NaN | 78759MARTM | mmoreno@imisdemo.com | False | False | NaN | Mario | 11044 Research Blvd.-Building B, Suite 300-Aus... | Mario Martinez | NaN | NaN | NaN | Mario | NaN | NaT | MARTINEZ, MARIO | Martinez | 2014-01-29 09:57:07.547 | NaN | NaN | True | N | 2010-03-09 | M | NaN | NaN | NaT | DEMO | 2017-12-31 | 258 | NaN | NaN | NaN | NaN | NaN | TX | NaN | A | NaN | NaN | NaN | BRIANM | NaN | NaN | NaN | 78759 |
| 5450 | NaN | NaT | NaN | NaN | NaN | Austin | 229.0 | CM | Creative Distractions | False | CREATIVE DISTRACTIONS | 0 | United States | NaN | NaN | 2010-03-09 00:00:00.000 | NaN | NaN | 78759BENAJ | jbianchi@imisdemo.com | False | False | NaN | Juan | 11044 Research Blvd.-Building B, Suite 300-Aus... | Juan Benavides | NaN | NaN | NaN | Juan | NaN | NaT | BENAVIDES, JUAN | Benavides | 2014-01-29 09:57:07.547 | NaN | NaN | True | N | 2010-03-09 | M | NaN | NaN | NaT | DEMO | 2017-12-31 | 259 | NaN | NaN | NaN | NaN | NaN | TX | NaN | A | NaN | NaN | NaN | BRIANM | NaN | NaN | NaN | 78759 |
| 5451 | NaN | NaT | NaN | NaN | NaN | Hobart | 18996.0 | NMC | YHA Industries | False | YHA INDUSTRIES | 0 | Australia | NaN | NaN | 2010-10-24 00:00:00.000 | NaN | NaN | 7000BAUGJ | NaN | False | False | NaN | Jerry | 51 Macquarie Street-Hobart, TAS 7000-AUSTRALIA | Jerry Baugh | NaN | NaN | NaN | Jerry | NaN | NaT | BAUGH, JERRY | Baugh | 2014-07-25 15:22:20.720 | NaN | NaN | True | D | 2014-12-17 | M | NaN | NaN | NaT | DEMO | 2017-12-31 | 260 | NaN | NaN | NaN | NaN | NaN | TAS | NaN | D | NaN | NaN | NaN | BRIANM | NaN | NaN | (038) 664-0921 | 7000 |
| 5452 | NaN | NaT | 261.0 | NaN | SOUTH | Brussels | 18147.0 | CM | Hardwick & Connolly | False | HARDWICK & CONNOLLY | 0 | Belgium | NaN | NaN | 2011-01-13 13:27:27.107 | NaN | NaN | 13 11GANTL | lgorman@imisdemo.com | False | False | NaN | Leisal | 333 First St-Building C-13 1140 BRUSSELS-BELGIUM | Leisal Gant, III | NaN | NaN | 5551212 | Leisal | NaN | NaT | GANT, LEISAL | Gant | 2013-12-17 16:27:15.000 | NaN | 123456.0 | True | N | 2011-06-17 | M | NaN | NaN | 2011-06-17 10:00:39.593 | DEMO | 2017-12-31 | 261 | NaN | NM | NaN | NaN | NaN | NaN | NaN | A | III | NaN | NaN | BSCHRADER | NaN | NaN | NaN | 13 1140 |
| 5453 | NaN | NaT | NaN | NaN | NaN | Eden Prairie | 18013.0 | CM | iMIS International | False | IMIS INTERNATIONAL | 0 | United States | NaN | NaN | 2011-04-08 05:36:11.790 | NaN | NaN | 55347BOURB | bbrett@imisdemo.com | False | False | NaN | Bernard | 8910 Sylvan Rdg-Eden Prairie, MN 55347-3336-U... | Bernard Bourdain | NaN | NaN | NaN | Bernard | NaN | NaT | BOURDAIN, BERNARD | Bourdain | 2014-02-16 14:20:51.423 | NaN | NaN | True | N | 2011-04-08 | M | NaN | NaN | NaT | DEMO | 2017-12-31 | 262 | NaN | NaN | NaN | NaN | NaN | MN | NaN | A | NaN | NaN | NaN | BSCHRADER | NaN | NaN | (516) 987-2222 | 55347-3336 |
| 5454 | NaN | NaT | NaN | NaN | NaN | Eden Prairie | 18013.0 | CM | iMIS International | False | IMIS INTERNATIONAL | 0 | United States | NaN | NaN | 2011-04-08 05:44:02.290 | NaN | NaN | 55347BESIP | pbelenkin@imisdemo.com | False | False | NaN | Phil | 8910 Sylvan Rdg-Eden Prairie, MN 55347-3336-U... | Phil Besinger | NaN | NaN | NaN | NaN | NaN | NaT | BESINGER, PHIL | Besinger | 2014-02-16 14:20:51.423 | NaN | NaN | True | N | 2011-04-08 | M | NaN | NaN | NaT | DEMO | 2017-12-31 | 263 | NaN | NaN | NaN | NaN | NaN | MN | NaN | A | NaN | NaN | NaN | BSCHRADER | NaN | NaN | (516) 987-2222 | 55347-3336 |